About Program
MySQL is the most popular open source database. One of the most highly in-demand skills in the business sector today. Become skilled as a database developer generally needs you to learn a database and then database design.
It’s a great choice to begin your learning journey. Many companies today use MySQL, including Facebook, Dropbox, Udemy, Slack, and many others. This courses will helps you master a skill.
Key Highlights
- In-depth knowledge of database design
- Data Analysis
- Learn about RDBMS
- Knowledge of Normalization
- Generate Excel Data Reports
- Learn Aggregate Functions
- Run complex queries using logical operators and string functions
Prerequisite knowledge: Access to computer. No Database, SQL, or MySQL experience needed.
Curriculum: 21 Lessons – 36 hours
- Introduction and Installation of MySql
- Database and Tables
- MySql Data Types
- MySql Operators
- MySql Statements
- Storage Engines
- Types of MySql Clauses
- How to use Joins in MySql
- How MySQL Uses Indexes
- Aggregate Functions
- Math Functions
- Date Functions
- String Functions
- Full-Text Search
- Database Import and Export
- Control Flow Function
- Primary Key and Foreign Key
- Subquery in MySql
- What are Temporary Tables?
- MySql Triggers
- MySql Injection
This Program is for
- Looking for Database administrator, Business Analyst job opportunities
- Become an expert in Database
- Boost your career by learning an in-demand skill
- Add data analytical tools to your skillset
- Learn database architect and data modeling using MySQL Workbench Tool